Skip to main content

S3 Tables

Overview​

When you create your metadata table configuration, your metadata tables are stored in an AWS managed table bucket. All metadata table configurations in your account and in the same Region are stored in a single AWS managed table bucket named aws-s3.

For more information see https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables.html
and https://docs.aws.amazon.com/AmazonS3/latest/userguide/metadata-tables-bucket-integration.html.

You can query your S3 managed metadata tables using the Qarbine drivers below.

Amazon Athena​

https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-integrating-athena.html

Amazon Redshift​

https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-tables-integrating-redshift.html

Trino driver​

https://aws.amazon.com/blogs/storage/query-amazon-s3-tables-from-open-source-trino-using-apache-iceberg-rest-endpoint/

Permissions​

To query metadata tables have these permissions:

  • s3tables:GetTable,
  • s3tables:GetTableData, and
  • s3tables:GetTableMetadataLocation.

If your metadata tables have been encrypted with server-side encryption using AWS Key Management Service (AWS KMS) keys (SSE-KMS), you must also have the kms:Decrypt permission to decrypt the table data.

For more details see
https://docs.aws.amazon.com/AmazonS3/latest/userguide/metadata-tables-bucket-query-permissions.html.